OFFSET( <value>, <periods> )
Gets the value offset by the specified number of periods.
Function Parameters| Parameter | Description |
|---|
| <value> | The value to look up. |
| <periods> | The number of periods to look back or forward. |
Note: A negative
<periods> value retrieves previous values, whereas a positive
<periods> retrieves forward values (looks ahead).
Back to the Scripting Function Reference